SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393691 LIMIT 1 [ RunTime:0.000536s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393691 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151943,899922,804985,512721,327176,573084,146369,46635,931471,452198,160395,167813,781423,381044,863790,664591,888980,385793,433278,174970,1932,248930,1023824,332200,478586,310205,295482,874200,1018253,434060,473664,254018,1010462,184758,247443,230965,958190,818480,653300,751011,595376,886711,448665,384198,278572,621002,298005,207553,344380,519041,218149,441723,732149,272529,571364,570273,152258,566004,692232,738565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]