SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382960 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382960 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (247547,548654,478052,593694,127501,1024439,811255,467095,84210,134301,506356,649870,370428,128117,289787,18222,174740,511760,692136,249668,383734,870887,738846,64813,730439,25795,688245,731411,798825,714489,729961,170208,1029052,409395,995208,1030549,151652,550452,656790,61421,195044,943184,161899,436326,7390,64108,398122,464344,30695,584238,472518,196171,496626,577238,980552,570533,145621,664071,270968,115446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]