SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103899 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103899 [ RunTime:0.002526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570435,381554,827295,1023038,936102,947543,751783,810655,1026188,838431,656987,896854,621756,755317,858574,383765,324101,553623,971120,930570,779957,855398,709325,568413,476605,843204,893277,206332,267766,13412,240742,1008036,672037,515281,682090,543488,980349,774245,103528,1018479,610004,391242,357012,1036370,991975,291626,140819,462681,523188,332808,531041,502302,266595,906878,445859,881212,771781,850875,13611,178404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]