SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301096 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301096 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599910,818439,870762,855099,1011144,864996,451015,650871,867107,773050,651438,82101,842319,259833,918234,580428,528027,224677,918697,670854,713463,568377,674117,192834,341153,180499,786033,833315,264855,885180,177719,321419,624919,729123,896018,989721,589732,757664,386001,943230,891877,1036338,131734,435468,256437,549718,620117,511565,484034,702740,106108,101059,306150,597212,180096,608549,857923,357990,277791,189197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]