SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507223 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507223 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414845,653770,372293,542164,1020563,688177,938419,128208,514139,980620,762436,311612,1014688,159374,453982,773026,520543,430017,59028,109179,234660,981144,586977,630375,376276,597778,147195,874130,1003512,111124,34018,80300,300668,971800,756357,809565,682756,951341,86309,425955,393277,441920,641283,203464,671062,370644,442957,216295,104019,392175,480712,250484,738868,256594,637790,212582,644919,967794,203618,994066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]