SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394012 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394012 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253868,838214,259762,983144,616895,812966,552059,1018320,666584,11121,697339,459121,621925,52433,439593,83937,450863,234815,326269,667673,863957,542256,765710,185163,108791,425280,862693,796767,603381,839402,576566,749020,691018,952782,743536,272353,89452,623112,249855,1037841,576381,158805,282544,653295,1000205,406023,621931,428247,265603,459822,222106,180440,34009,132255,742150,636552,830859,756511,581682,873821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]