SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001665s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389741 LIMIT 1 [ RunTime:0.000683s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389741 [ RunTime:0.003131s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489655,392744,270690,996527,349398,363028,410682,573787,670255,866152,992549,166193,104269,505365,168325,100720,712456,870079,26726,151375,395263,170285,525876,346168,687057,879376,734307,111872,63771,1031957,706564,418066,129581,327119,720090,342381,336521,51231,929354,5595,887250,59273,1044319,169448,947188,575222,999271,1024778,18332,512310,56423,562690,50111,484693,122010,292397,373100,115730,365638,671745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]