SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001781s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575023 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575023 [ RunTime:0.002134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90899,901887,820387,381825,958683,235952,45980,485566,466052,1027510,201246,1044005,413274,749116,945158,91759,943523,675677,638937,923845,217310,604024,460527,621642,180581,299358,118909,806432,565039,350618,302730,375786,810502,813849,605617,285983,557622,823681,188918,426213,717559,775310,431262,726952,664428,886234,746403,334639,481887,501658,793773,552356,561725,702297,340171,455238,819935,1004890,36151,930222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]