SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542314 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542314 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498013,152288,19952,972121,542156,744172,41254,191986,492246,554797,713768,172658,580772,163831,141022,191306,19155,240275,137281,824737,822678,254998,551882,290355,256937,817821,134732,130048,330831,371714,93611,88330,539279,183825,748734,1012008,878398,994847,975481,500225,321145,786892,377905,149150,539438,814887,335283,428442,253109,718090,111411,202807,393063,352514,38157,838005,241763,582068,868894,774838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]