SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596201 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596201 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734227,590958,298902,1033180,445301,729390,272991,46767,989352,6375,338667,16620,204384,1037260,818434,229683,344642,121872,131074,783223,187490,554952,501752,273826,472805,212442,473892,1041893,536188,111502,531942,457256,1045264,893792,73055,27123,572233,730032,378202,87921,737861,500552,604328,985316,437248,274317,367589,769315,437646,309176,655874,158159,148949,713543,91386,1027253,765483,684819,652556,333467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002702s ]