SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51400 LIMIT 1 [ RunTime:0.000678s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51400 [ RunTime:0.003198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876566,318069,701877,778144,680988,1000696,895715,423490,905704,186552,991525,748770,57565,1802,961477,265508,860711,240881,326934,467601,989022,84506,424299,420481,830869,604515,173989,733348,500087,948749,592388,24651,146676,342554,860997,100571,841984,1047568,14444,336857,174110,118794,1029822,878530,799244,69477,902155,795162,202004,237039,630519,160873,702742,530863,693671,326302,2142,653454,820681,971755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]