SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022272 LIMIT 1 [ RunTime:0.000576s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022272 [ RunTime:0.001463s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116357,759725,99086,954261,990307,173933,390813,673201,986532,142220,892125,604694,69966,439138,80463,237502,1026325,1040046,735539,633271,558659,215724,132535,931883,931446,294178,898044,766263,548017,394926,1019402,540630,894025,1045104,326945,662674,652086,613749,545528,916180,575665,966503,544346,106440,1023412,182125,94824,245542,904624,280188,464127,67834,977478,189320,66290,817710,128841,999029,707422,893927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000857s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]