SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026185 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026185 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587960,277070,40149,982646,87643,614536,385228,93860,657752,471413,358838,693949,579774,206674,522741,486160,319251,86568,703830,602329,946230,594564,207646,350924,671721,1011879,350285,380055,1019645,1030478,588744,668815,54043,228023,8674,91344,419046,550704,616663,708434,655071,59040,360701,388905,287622,935000,597492,735220,184344,832873,597763,1035514,292654,958813,504398,840360,233596,814542,357273,235746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001889s ]