SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548475 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548475 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853794,457630,1017115,887129,832138,932904,113486,38603,524677,26019,498064,389356,840043,171758,702524,742956,143516,503605,627940,545808,825568,610603,57549,871921,487054,1006124,260939,934996,641762,24963,802604,364625,73727,884101,812397,419359,644938,532736,432026,395628,985006,301356,861691,985598,462759,436552,164723,69495,427101,105848,249407,702836,597056,867360,70139,230371,487101,925583,237217,651616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]