SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41473 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41473 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395184,579861,36804,398268,269682,412785,14409,435945,149298,488783,251592,14714,294027,78229,440626,1015299,39774,478722,757993,592739,58006,636149,778759,427114,99858,685244,716677,117998,405183,1035443,135509,880783,901774,627512,536804,218641,294657,906796,553445,1027157,185660,519252,776854,56196,709572,95522,512638,641045,353052,818380,812121,514742,496612,211323,1039874,897470,165925,592500,1013101,1000638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]