SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501398 LIMIT 1 [ RunTime:0.000693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501398 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273603,79113,599002,1043717,419646,613462,643679,649646,30609,351648,6429,15395,476674,482309,593256,607643,443041,282418,110767,364985,1044998,6660,155780,931148,875221,131264,978994,880603,339021,497832,763333,783958,337301,498500,706692,678563,187269,633824,896691,376040,894931,734090,384337,895468,355250,116030,1018450,7077,104035,900782,412313,260873,597961,597826,395663,85590,638611,19150,547861,320752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001026s ]