SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020480 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020480 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525702,235244,76569,478790,958148,696870,86645,852760,689746,57031,567971,1042149,828767,219305,609766,407838,1035740,942803,411865,113538,46630,411804,22600,946902,835769,661101,56318,934068,965595,932101,867962,197072,244775,978821,755028,610408,324619,947788,718370,759689,851259,4084,45856,510435,1010630,826001,956585,512864,838830,121112,412438,540606,913423,381076,933454,532203,127282,754105,207533,685096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]