SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021213 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021213 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257133,610323,91659,285011,805322,362760,414020,426783,142558,300263,594285,981416,1004623,601289,237144,492032,572301,628676,1019654,647720,902887,102439,853692,168912,134346,830031,677016,465875,730601,943274,1042702,136751,100178,131247,1007692,986456,356709,425607,411656,912951,518444,444431,727594,66373,305839,1047521,822335,10481,553556,78581,570992,907563,256885,677484,81344,587167,839238,346961,314430,700157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001314s ]