SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529090 LIMIT 1 [ RunTime:0.000701s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529090 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947802,67046,518376,88402,457845,990757,486100,212638,105053,223773,1006887,312974,12269,166100,885755,463810,522286,708591,499189,381722,260038,602185,524439,613531,1005098,156270,173827,408840,738826,482052,839540,136821,386614,802132,576633,71682,653029,51423,354093,274035,647314,612898,629568,343083,929529,694095,542098,796720,976122,60097,219613,480343,469020,537671,393571,437412,994945,705196,314059,945051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000745s ]