SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001604s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601959 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601959 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405843,451449,292259,431895,112850,1003806,310217,648213,193329,416488,635120,758085,33941,576212,879766,20805,862005,797762,878372,397934,739224,949052,992433,863838,369830,846187,305298,843255,114997,580368,821507,1030081,535490,58647,805890,467297,903609,570419,963168,575214,744735,721519,688292,233410,580503,451305,713662,477888,588450,963778,120649,276536,43592,308056,526144,984732,747025,759501,736688,48379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]