SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538801 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538801 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652888,117417,116918,153123,182553,343933,900984,928361,59463,763075,719557,194356,164085,851367,781695,777900,165717,173477,898476,91671,300091,204974,891796,619949,1040347,371885,229137,1043549,735620,817479,641343,75844,683331,572770,65546,127518,839672,680935,616176,104377,402508,794259,161158,432092,264411,942028,408418,573357,897815,1011344,685521,642852,33018,152473,179470,489478,637428,1776,554765,224816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]