SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291009 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291009 [ RunTime:0.003542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (179813,932212,794189,356903,418492,1349,550435,96979,637855,193742,584365,233491,894521,1003403,595278,85378,508517,197286,462954,536114,21603,991913,1001023,599579,41516,541802,629683,267605,684256,1046798,405577,985539,31515,602031,122695,77729,243379,201017,263626,484272,846755,269324,268833,984618,657256,627537,274450,371698,72362,981518,10451,356278,509076,292097,832067,651079,654045,367718,1012259,1039864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]