SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841211 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841211 [ RunTime:0.001517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558491,801367,208120,207734,671626,435001,476123,354800,322901,157492,355752,35106,285347,706466,762032,486173,1014229,397872,449302,307914,12027,744873,409680,188185,684521,993328,240908,155958,16888,701664,559874,462061,17346,482529,542633,645764,966958,621893,223170,641576,664284,341412,10269,875395,25020,634360,408689,601597,768135,736224,822412,237074,567887,994934,51517,563030,1005373,978237,946473,506763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]