SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424431 LIMIT 1 [ RunTime:0.001212s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424431 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319241,73663,498304,362337,3870,1007613,922938,522305,47531,953198,475398,495970,699927,33890,823518,45994,655363,598557,1044614,8520,500523,454384,708177,908393,88855,872642,301837,17328,322282,207761,189850,116356,3478,235633,38505,395405,743709,939717,633991,930265,628867,215244,807136,786683,784036,70850,667448,490700,250518,289279,682357,151579,478191,325413,869549,866758,713531,660067,359425,710635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000447s ]