SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105625 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105625 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953954,77968,24108,408784,512616,894629,985014,1028244,755760,830024,639739,712119,407626,272712,401154,189642,545798,750595,499015,145218,849921,163055,276626,873934,882318,294403,720149,172628,669525,899673,799178,475501,638258,200426,872365,89154,222391,756280,310448,293609,900807,956849,170059,312887,31800,212826,700359,626978,706091,4143,888000,286361,344740,792662,1004117,295662,297022,833740,305026,82314) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105625 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105625 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]