SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411795 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411795 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38022,393983,507843,125463,218201,39602,194265,36755,7521,750849,762157,326948,501229,160211,70083,237855,605771,573472,763956,247617,171151,864544,187657,352277,831804,316439,204307,243904,193199,501908,943860,401329,896280,128890,364532,998790,591981,313078,80138,342367,19548,184121,121292,17423,355314,949201,546074,133412,459897,244250,513337,82163,575380,450773,124061,880452,852100,935991,458508,671733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411795 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411795 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]