SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013009 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013009 [ RunTime:0.002126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (812174,759178,515547,741102,419737,322428,700235,827713,752517,270142,647914,170609,592871,135048,539206,472235,888989,894117,25629,729249,680361,433591,192643,991529,31152,403156,81279,580338,798936,724927,956783,82503,482126,73955,426919,150914,37726,231911,107014,592802,975068,324830,139568,769925,739394,362237,118465,292857,658849,931985,810471,352134,14158,40049,325709,459817,971147,130541,932687,571326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]