SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414203 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414203 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926245,1037706,150007,641349,300726,637033,1016355,588485,592811,470829,748532,720669,622563,599477,659690,219983,859310,521113,614569,541723,669108,523830,366566,388934,602386,664393,634600,460506,487124,512555,814155,722903,426393,132098,41788,292255,669608,1043537,111205,101456,178892,143710,751575,316035,45,684213,707863,313936,251816,602521,875961,271152,651015,658446,841106,576623,375299,1023845,461912,741057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000719s ]