SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501160 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501160 [ RunTime:0.003508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810805,898759,286658,1046317,911096,355437,407884,861812,803630,420314,83719,529961,139241,691826,143383,625024,822824,348245,520041,706270,735103,227836,573788,791582,579211,899705,922163,511901,508131,737461,108199,378599,576207,322841,382646,669357,895327,613114,251602,686700,932215,213411,692606,577236,926194,485888,59409,436293,166635,542167,424910,968705,973578,327031,634071,560253,162034,97751,639762,236722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001003s ]