SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 691083 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 691083 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240975,379479,855773,209091,920365,748405,389324,632846,80130,432303,560993,69028,717531,170187,866878,880449,433049,576336,678512,484180,155668,651996,383798,875688,422764,1028717,1030354,997078,133386,754505,444250,71280,718644,701499,711809,578313,494997,143050,637976,984567,714692,890012,592849,326248,791313,155807,987818,917099,520644,336358,122467,692824,969355,367179,785994,374125,999432,715806,733886,602189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 691083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 691083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004108s ]