SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014514 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014514 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452645,731405,119842,645425,152999,253493,57305,566963,242332,675931,343792,491155,500042,595048,625441,207131,916829,608573,407978,592406,290926,540813,894996,838454,696028,275134,913599,156681,957657,572723,763122,981411,173597,244372,792835,133898,418622,933470,805636,230985,980415,301898,400363,667808,118858,352260,671811,74859,145499,859349,512340,744232,246550,177365,714119,440212,168214,552778,563481,312995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]