SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021677 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021677 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733892,114628,16643,384680,984685,152596,953721,112257,722264,665659,47559,415976,836762,239678,377934,141895,760360,500237,266513,439886,625203,321198,819876,455975,17793,1022147,808695,825187,396642,7658,31440,137144,433338,122079,1041688,799893,328654,467831,332893,14814,138565,801111,338658,690760,730112,938770,994468,557934,609399,94675,376306,679298,269626,669957,772803,146532,186485,652237,753124,677429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021677 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021677 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]