SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464080 LIMIT 1 [ RunTime:0.000669s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464080 [ RunTime:0.002401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042418,172156,345301,274979,375221,447008,228567,216906,820711,543528,671656,658854,37955,1029787,682871,554427,50812,475519,106382,758110,198296,631500,197389,727481,373499,840106,790447,862657,583742,262764,525895,93326,550125,151981,961580,788880,220112,501724,1045597,662824,261350,1007485,151425,682058,606157,289710,60491,5394,964644,908141,359068,341959,620417,983251,721966,130182,146210,733926,146765,102459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]