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` = 905613 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905613 [ RunTime:0.002774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393669,314993,802683,10428,669913,555075,483812,926897,766499,946311,426940,155406,240425,701651,815488,298880,344474,750558,333507,528020,27198,299808,898391,382049,945833,2511,909207,703294,96211,566407,963410,444144,92737,164485,191422,408266,913016,334166,622168,139502,922267,424634,202671,122627,495616,533896,402563,555019,1032680,714087,353111,949085,631071,373778,900922,348201,43562,942161,53912,640686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000634s ]