SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517183 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517183 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374007,398571,713853,11178,279037,1023821,69694,721470,106016,2454,351830,315099,1003530,1045289,419246,51661,95951,516528,871819,914123,842170,52506,599138,1040086,495866,413484,82765,610778,379604,889537,648506,164092,852091,519114,308962,306744,48164,715491,86548,575516,961707,1004515,882123,682889,170153,928436,19982,1031154,300884,191475,518984,31817,583148,915451,396929,555862,180846,966302,134169,1003055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]