SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804201 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804201 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932507,698765,782321,786532,637458,984118,330543,491942,703959,382098,1044277,994994,779663,594121,619353,17120,930000,420581,749781,554549,973125,205234,218127,654276,630696,1028966,74146,698974,153349,896778,288456,768494,471819,876803,426632,876613,572600,33038,334261,116974,425110,817710,404414,709027,82843,718706,819679,899600,668899,71834,63802,584962,841751,282020,507427,784716,501694,624181,429573,600819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]