SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502335 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502335 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509315,808474,91102,932182,155611,365111,532177,966802,528160,741796,872832,922359,795194,470449,28434,710219,737961,324238,982719,38529,542316,562848,792654,523370,211960,511587,1875,424573,1000938,613910,856270,543374,541032,907800,792014,534911,791137,442130,832848,350210,265189,875704,1039703,396877,615138,266287,413983,763959,765121,308728,388168,284996,40843,213345,701671,466735,597057,655451,158696,321822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]