SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410140 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410140 [ RunTime:0.001972s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440503,474296,219256,891616,1048699,457484,843148,966844,597709,648174,359192,407441,260867,926715,610887,297465,916,851229,777958,488997,938334,881055,154612,1029674,253189,103657,786920,138199,674836,527067,712741,493101,794757,100267,621917,138174,497248,888122,904724,119194,95362,825979,14302,572099,634993,89596,176080,808190,785127,620498,845316,797745,375754,884575,466234,1033737,935384,74567,602334,667071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]