SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430791 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430791 [ RunTime:0.002176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447586,762830,727554,597793,664176,822080,202987,527319,579728,463860,328411,1016570,142795,845677,673454,204338,37204,641699,752805,962398,47600,302870,901499,986285,426763,648620,152913,318011,89636,136747,375219,445048,287174,988613,758210,330330,852037,601559,12043,930736,181971,735056,111843,563165,133986,471758,831292,9048,1039483,364765,971854,766873,280890,811804,149138,920298,605694,91603,113011,29802) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]