SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039766 LIMIT 1 [ RunTime:0.000843s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039766 [ RunTime:0.003733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503329,303011,826488,408150,640085,110177,698598,288896,506177,417898,396848,749108,402982,654132,973543,85752,367577,66296,130494,564305,643628,701648,90416,858906,724206,593925,678817,221892,159101,1000231,56340,343389,250468,866618,109959,954985,31559,688328,219342,595014,732579,796125,219336,353677,513677,739822,469062,698989,820080,1002150,292459,728279,689169,859001,520178,184127,1021025,839539,798711,713896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039766 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039766 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]