SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861023 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861023 [ RunTime:0.003861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506931,542040,303279,781330,684528,423951,515030,11384,314886,771893,959741,930480,399641,887640,450466,128988,296895,648418,365570,581251,704021,106749,858556,907970,642493,929253,410372,983111,915241,500206,747703,594685,355659,206668,544151,913016,260007,1001846,207249,623432,692348,607128,550279,118709,1048606,336964,328325,347890,702706,400762,647258,880749,334652,1010928,272822,143628,621118,400812,727600,561660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001917s ]