SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551016 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551016 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831381,19367,171772,424629,549156,123414,30113,258925,925590,573062,242249,56712,781947,455043,733301,622067,1036943,1043692,689573,844402,413294,357465,141161,1024992,567593,749507,889398,595762,245222,28567,618119,305753,268219,991998,861135,714121,426468,985752,871299,471989,206319,220766,228195,812751,880938,808106,573091,240078,11877,119270,946568,585915,841315,450770,57792,280692,97754,449871,567348,619335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]