SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022822 LIMIT 1 [ RunTime:0.000947s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022822 [ RunTime:0.003586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709296,910134,762761,830602,27547,629766,487384,823262,745714,412877,279798,156319,313793,595869,201889,613645,935114,158702,700533,501208,620526,350588,369773,272027,153670,545522,81408,740120,739698,313376,487314,946329,830253,513345,471374,549438,92585,813198,430038,313347,362272,145814,238845,317614,192646,385616,473488,402749,221126,678173,682070,225703,752466,400074,375418,728992,794363,82058,65879,374048) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003824s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]