SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019638 LIMIT 1 [ RunTime:0.001357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019638 [ RunTime:0.006187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458708,598287,719863,429683,405760,1020632,651640,871899,784100,913117,392454,187972,100835,430403,810846,91086,1019761,170803,456632,867921,977415,878927,1044996,953208,522815,540338,520523,130334,486072,599825,911661,882549,1039286,234389,234845,904079,147727,939498,149827,966590,537515,326372,909320,541517,90402,851302,336020,548575,545735,593826,145702,648116,801601,1044918,146826,231199,204704,880346,206605,872698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019638 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019638 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]