SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381078 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381078 [ RunTime:0.004386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465283,539793,233252,456969,977716,490258,935155,702485,896114,735203,979582,100121,859732,176114,50854,174679,269637,611190,228180,434909,213435,179269,879221,736105,628565,959749,311078,103376,263021,121011,509894,783356,290052,242463,210275,492362,183639,61764,305648,465051,257657,857021,887579,737966,650183,895052,528957,361900,809313,687896,958583,960667,104004,518593,37020,284079,660355,129412,60436,487976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]