SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567813 LIMIT 1 [ RunTime:0.003365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567813 [ RunTime:0.003419s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114230,434842,50316,598458,597360,79082,956363,315097,364345,599666,531006,109880,1002902,1023035,74799,154222,947566,206886,564535,19471,855245,652396,7760,776723,128142,378627,397638,709314,911586,564663,919293,425916,473474,493808,465969,242888,231403,49582,278671,308231,766509,273301,598492,286251,192096,78554,744860,306074,910917,563905,271569,748671,178753,132348,727608,1046702,959675,820258,392413,630203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001412s ]