SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433258 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433258 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441102,289118,956949,353891,1031066,483641,225757,557737,201722,517941,155263,1009848,124477,582034,304731,990278,215178,593643,903332,751825,91364,115299,713871,88525,929420,452967,991424,453935,786679,619709,961809,36075,145393,731023,360647,439364,361132,258161,249803,1035165,950208,825354,706883,372603,1017188,1037708,13744,819222,85676,602749,796548,941927,100783,613544,608970,398037,531419,508913,845693,77540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]