SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341851 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341851 [ RunTime:0.002036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42062,271073,747924,800826,809235,44327,593486,1046786,671459,730567,552526,778940,738107,221991,990816,1503,528956,403840,736653,130505,931695,958362,478109,987757,168436,379430,159489,272220,366439,603957,395721,385752,141700,598060,409337,492286,275902,151938,357445,473715,137679,794957,229357,898804,234335,950790,739557,460456,27305,214760,579146,163631,91876,310272,964227,285104,683096,796252,9626,640022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]