SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473218 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473218 [ RunTime:0.002936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903590,956812,148104,448465,106644,299779,443069,373663,458876,1041583,167084,84236,688505,845835,389503,384474,175862,652249,538614,38365,475387,13751,918747,802228,217753,482009,963447,3243,321639,239340,622977,576637,918904,224514,278795,276630,359359,109630,512213,94364,312574,764932,968827,977571,875402,804935,87721,163666,75803,819454,627770,641146,392093,912974,118593,444666,660171,299643,569486,51545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]