SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52534 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52534 [ RunTime:0.002601s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020208,687269,614084,920648,1004822,602912,297582,287507,963310,200287,999514,253437,989462,559288,322924,13682,186585,909502,637585,625490,178457,240768,99666,284143,588313,650096,700763,560533,986999,868670,141235,577669,917136,830717,461318,495098,504873,475241,93015,313700,1030856,333988,188402,354818,182386,191046,976353,1045455,285604,511358,766077,150875,1030857,783309,158683,807631,388877,351398,475986,165640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]