SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508043 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508043 [ RunTime:0.004221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119477,275816,646706,197030,950096,97623,190151,237450,626865,690889,925905,935506,925696,472651,64197,766261,705180,807982,87447,712281,861347,368960,805891,1029692,423006,203571,951761,382276,607653,947118,462475,646610,910140,291660,210065,2893,629071,350654,86489,637855,298324,896784,282978,706811,597831,686423,125894,18366,902056,855350,404051,424158,215398,649054,718243,758553,18375,709698,475015,330897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]