SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102533 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102533 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580124,71023,615416,359232,762040,420130,522007,982000,336458,1038292,112793,975267,616562,433558,486580,330737,453262,1040917,473467,1041881,569168,829600,78366,795935,816035,491681,297378,569135,1038166,994463,365377,22143,785515,9402,713314,867600,525763,539805,704398,1024669,956469,156123,905835,1023633,293076,903447,821674,398981,357528,355281,809838,81271,179301,980817,675343,389538,397531,93392,825414,438838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102533 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102533 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]