SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334870 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334870 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434934,760144,898007,456203,838910,351761,305191,814216,610072,340531,567098,431975,914895,353590,752011,41232,157478,461761,805669,789446,580365,574009,368352,806874,520088,186754,181670,12647,68369,550438,382237,543785,43029,512015,580612,1012768,305713,496782,365903,569676,387835,1003711,884434,326586,29192,473674,836250,540244,765709,655509,31301,976216,1044273,423824,182810,188185,282335,606534,301996,623973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000824s ]