SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 664480 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 664480 [ RunTime:0.003676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807200,421130,35493,572518,635542,275565,261234,492340,693282,183585,451270,757566,12287,280654,868144,212847,136346,423185,971405,357516,62035,923804,571382,1012602,1023659,701036,972327,130531,311977,953040,511472,594708,417657,26512,47498,127594,316077,855436,974533,64134,140797,371891,1008584,830363,389714,1047308,536336,7210,217015,83729,690397,788261,740249,833605,165804,560640,874900,453403,396045,698649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 664480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 664480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]