SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002861s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545721 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545721 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946832,1038053,177250,974000,928168,161214,215906,14919,323223,393046,379897,1019386,135032,528507,745456,452105,995778,155845,75170,269833,837166,1008836,349847,194286,391939,44381,195464,644649,677894,673860,641925,846607,534542,909446,907186,727534,1019953,675038,307724,551404,553337,43118,220794,170087,535080,204195,168152,395143,401670,106868,67957,45660,750347,18093,692766,194818,881525,417456,475425,624027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001223s ]