SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204301 LIMIT 1 [ RunTime:0.000746s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204301 [ RunTime:0.003361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982099,371928,134344,918881,48649,796929,436377,856980,691617,80911,525254,904387,31093,320658,951239,855150,639660,6089,162768,266995,887389,496938,47001,137108,970360,18797,549341,768669,307557,237476,103402,841513,619962,917957,843802,993519,310752,765109,159088,873182,37408,961668,501656,529699,227234,751687,19021,386727,1037342,720217,916695,510926,4256,751805,556594,977488,497708,185811,391932,1035555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]