SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455231 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455231 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724474,944623,698921,547792,1045488,1007888,267119,467803,1022861,130400,56442,245648,926582,1022026,948866,545808,932656,972491,613718,788579,915032,182831,236426,919517,322398,651149,365669,1024334,448553,67599,317945,237378,277023,536505,545567,322325,947020,721185,1017041,252791,345,372349,969305,792144,853867,420983,791938,784188,1033077,682529,593321,242687,714893,84907,344932,332633,180759,773128,940249,520448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455231 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455231 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]