SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001381s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423288 LIMIT 1 [ RunTime:0.000778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423288 [ RunTime:0.003908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028362,1038193,641594,1042072,468861,279845,379180,802813,631160,653586,109500,323675,827140,831697,1028891,435663,677360,863431,816710,98655,517434,792124,229688,323569,514637,774614,867419,842535,803596,98266,516672,135215,174992,316778,349144,412978,280534,198899,760009,409175,744693,670120,112464,1009233,803810,206071,347860,842463,26691,1046863,789426,176275,1043957,991098,523121,74868,332389,933905,689876,540177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002238s ]