SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291463 LIMIT 1 [ RunTime:0.004008s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291463 [ RunTime:0.003598s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835339,513218,763329,377303,103164,204793,279268,449583,217994,562145,235349,858167,847803,692550,701763,229818,672066,168739,460780,760652,367798,485528,1022970,105198,66436,184817,153015,213139,1009292,579647,331061,627162,107450,850161,960759,817944,342623,705866,489296,795870,94790,928257,321627,476938,792706,625305,520488,985192,423468,243477,634999,833112,393222,423730,85800,404716,379820,39473,234323,195876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]