SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441315 LIMIT 1 [ RunTime:0.003163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441315 [ RunTime:0.005546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255542,127693,587109,239880,76689,393341,537944,209349,443690,513809,367888,314803,908304,642827,737451,573289,898528,828723,614043,81484,42129,1039164,164900,310207,848764,222688,389496,588037,398554,972845,370965,143107,791146,657497,739220,604684,757164,454248,347720,955321,201307,837430,265544,265538,595148,837657,804729,253353,489680,932453,1044429,784439,481208,949012,437814,736573,702967,828648,19089,1040005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]