SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520501 LIMIT 1 [ RunTime:0.001127s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520501 [ RunTime:0.003048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533620,260640,841421,131750,442116,135521,700698,245221,582377,911983,504431,419736,260189,969904,866601,467876,459693,49375,213656,422342,74821,585239,419580,1023119,1002825,470478,964684,101001,419992,256261,515115,284840,833168,893163,110957,439096,1045207,760636,745033,663376,922509,957535,493535,166818,260358,899372,402388,932040,875787,1016568,456019,116139,241694,61654,469579,553826,412581,217833,457453,395998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000865s ]