SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 145141 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 145141 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575238,930198,379613,311884,797259,119331,383938,110372,29546,241412,33077,389430,37873,21318,706724,915860,403487,1043654,119742,613732,16162,699193,593413,874287,629126,805634,619686,3879,965415,74489,382472,136668,944966,443694,118702,197115,637971,604161,305033,12862,689849,418310,519776,747808,201961,822322,6990,1036486,362262,741364,700079,499078,735869,245058,125677,372804,656453,342471,815120,368058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 145141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 145141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000380s ]